package com.zygh.policeasset.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/PurchaseAssetsBusinessMapper.class */
public interface PurchaseAssetsBusinessMapper {
    @Select({"SELECT  count(*)  FROM  assets a  LEFT JOIN ( SELECT * FROM project WHERE category = 4 AND pid != 0 ) p ON p.project_no = a.build_num  LEFT JOIN purchase_assets_business pab ON pab.project_id = p.id  WHERE pab.flow_no = #{flowNo}"})
    Integer queryByFlowNo(String str);

    @Insert({"insert into purchase_assets_business(project_id,flow_no)values(#{projectId},#{flowNo})"})
    int insert(@Param("projectId") Integer num, @Param("flowNo") String str);
}